Show AllSelects the specified object.
expression.Select
expression Required. An expression that returns one of the above objects.
Select method as it applies to the Sheets, Worksheet, and Worksheets objects.
Selects the specified sheet.
expression.Select(Replace)
expression Required. An expression that returns one of the above objects.
Replace Optional Variant. True to replace the current selection with the specified object. False to extend the current selection to include any previously selected objects and the specified object.
Select method as it applies to the PivotTable object.
Selects an object in a PivotTable list.
expression.Select(Selection, ActiveObject, ScrollType, Update, Notify)
expression Required. An expression that returns one of the above objects.
Selection Required Object. The object to select.
ActiveObject Required Object. The object to make active within the new selection.
ScrollType Optional PivotScrollTypeEnum. Specifies the method to use to scroll the new selection so that it is visible.
| PivotScrollTypeEnum can be one of these PivotScrollTypeEnum constants. |
| plScrollTypeAll |
| plScrollTypeBottom |
| plScrollTypeLeft |
| plScrollTypeNone default |
| plScrollTypeRight |
| plScrollTypeTop |
Update Optional Boolean. Determines whether the display is updated immediately. The default value is True.
Notify Optional Boolean. This argument is not supported.
This example selects the cell that is one column to the right of and in the same row as the active cell.
Spreadsheet1.ActiveCell.Offset(0, 1).Select